package com.wms.dao;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.wms.entity.WOutStore;
import com.wms.vo.WEntryStoreInfo;
import com.wms.vo.WOutStoreInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 出库单表(WOutStore)表数据库访问层
 *
 * @author Li Xiaoyu
 * @since 2023-10-22 21:32:57
 */
@Mapper
public interface WOutStoreDao extends BaseMapper<WOutStore> {
    @Select("select a.id,a.create_time,a.out_id,b.`name`,c.product_name,a.p_num,a.p_price,a.total_price,a.creator," +
            "a.note from w_out_store a,w_store b,w_product c where a.store_id=b.store_id and a.pid=c.product_id")
    List<WOutStoreInfo> selectAll();
    @Select("SELECT DISTINCT out_id FROM w_out_store ")
    int[] selectAllOutId();
}

